﻿// ====================================================================================================================
// Project: Camstar InSiteExtractor
// Source File: InSiteExtractor.cs
// Author: Roop Sin LE
// Created(MM/DD/YYYY HH:MM): 08/13/2010 9:14:21 PM
// Copyright: Camstar Inc.
// ====================================================================================================================

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace InSiteExtractor.Definition
{
    /// <summary>
    /// Contansts used in the program
    /// </summary>
    class ExtractorConst
    {
        public const string IgnoredSheets = "IgnoredSheets";
        public const string IgnoredWorkbooks = "IgnoredWorkbooks";
        public const string Product = "Product";
        public const string Extract = "Extract?";
        public const string MonitorInterval = "MonitorInterval";
        public const string OracleClient = "System.Data.OracleClient";
        public const string ObjectName = "NAME"; 
        public const string ObjectBase = "BASE";
        public const string ObjectRevision = "REVISION";
        public const string TableName = "TableName";
        public const string CdoName = "CDONAME";
        public const string CdoField = "CDOFIELD";
        public const string FieldDbTableName = "FIELDDBTABLENAME";
        public const string FieldDefName = "FIELDDEFNAME";
        public const string ColumnName = "COLUMNNAME";
        public const string Ndo = "NDO";
        public const string SubEntity = "- ";
        public const int ColumnTypeOffset = 1; 
        public const int ColumnNameOffset = 2;
        public const int ColumnValueOffset = 3;
        public const int ExecuteColumOffset = 1;
        public const int CompMsgColumOffset = 2;
        public const string ExecuteAction = @"INSERT";
        public const int DataRowOffset = 3;
        
        
    }
}
